Owner

dbo

Creation Date

10-07-2003 10:31:35

Remarks

Columns

Key	Id	Name	Type	Length	IsNullable	Collation
		OrderID	int	4
		CustomerID	nchar	10		SQL_Latin1_General_CP1_CI_AS
		EmployeeID	int	4
		OrderDate	datetime	8
		RequiredDate	datetime	8
		ShippedDate	datetime	8
		ShipVia	int	4
		Freight	money	8
		ShipName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
		ShipName	sysname	80		SQL_Latin1_General_CP1_CI_AS
		ShipAddress	nvarchar	120		SQL_Latin1_General_CP1_CI_AS
		ShipAddress	sysname	120		SQL_Latin1_General_CP1_CI_AS
		ShipCity	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		ShipCity	sysname	30		SQL_Latin1_General_CP1_CI_AS
		ShipRegion	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		ShipRegion	sysname	30		SQL_Latin1_General_CP1_CI_AS
		ShipPostalCode	nvarchar	20		SQL_Latin1_General_CP1_CI_AS
		ShipPostalCode	sysname	20		SQL_Latin1_General_CP1_CI_AS
		ShipCountry	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
		ShipCountry	sysname	30		SQL_Latin1_General_CP1_CI_AS

Indexes

Name	Description	Group	Keys
PK_Orders	clustered, unique, primary key	PRIMARY	OrderID
CustomerID	nonclustered	PRIMARY	CustomerID
CustomersOrders	nonclustered	PRIMARY	CustomerID
EmployeeID	nonclustered	PRIMARY	EmployeeID
EmployeesOrders	nonclustered	PRIMARY	EmployeeID
OrderDate	nonclustered	PRIMARY	OrderDate
ShippedDate	nonclustered	PRIMARY	ShippedDate
ShippersOrders	nonclustered	PRIMARY	ShipVia
ShipPostalCode	nonclustered	PRIMARY	ShipPostalCode

Relations

Customers CustomerID

Orders   CustomerID

Shippers ShipperID

Orders   ShipVia

Employees EmployeeID

Orders   EmployeeID

Orders OrderID

Order Details   OrderID